Tabela ToothCodingTemplate

Definicja tabeli ToothCodingTemplate

Name

ToothCodingTemplate

Code

ToothCodingTemplate

Comment

tabela zawierajaca informacje o automacie (szablonie kodowania)


Lista kolumn tabeli ToothCodingTemplate

Name

Code

ToothCodingTemplateID

ToothCodingTemplateID

ToothStateKindID

ToothStateKindID

Name

Name

Code

Code

Comments

Comments

StartDT

StartDT

StopDT

StopDT

Active

Active


Kolumna ToothCodingTemplateID tabeli ToothCodingTemplate

Definicja kolumny ToothCodingTemplateID tabeli ToothCodingTemplate

Name

ToothCodingTemplateID

Code

ToothCodingTemplateID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ToothStateKindID tabeli ToothCodingTemplate

Definicja kolumny ToothStateKindID tabeli ToothCodingTemplate

Name

ToothStateKindID

Code

ToothStateKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID typu stanu zebowego


Kolumna Name tabeli ToothCodingTemplate

Definicja kolumny Name tabeli ToothCodingTemplate

Name

Name

Code

Name

Data Type

VARCHAR2(100)

Mandatory

Yes

Comment

 


Kolumna Code tabeli ToothCodingTemplate

Definicja kolumny Code tabeli ToothCodingTemplate

Name

Code

Code

Code

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

 


Kolumna Comments tabeli ToothCodingTemplate

Definicja kolumny Comments tabeli ToothCodingTemplate

Name

Comments

Code

Comments

Data Type

VARCHAR2(1000)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ToothCodingTemplate

Definicja kolumny StartDT tabeli ToothCodingTemplate

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna StopDT tabeli ToothCodingTemplate

Definicja kolumny StopDT tabeli ToothCodingTemplate

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Active tabeli ToothCodingTemplate

Definicja kolumny Active tabeli ToothCodingTemplate

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

Aktywnosc rekordu


Lista kluczy tabeli ToothCodingTemplate

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ToothCodingTemplate

Definicja klucza Identifier_1 tabeli ToothCodingTemplate

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment